{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["gederfd onderhoud","amsterdamse schaal"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"gederfd onderhoud","index":0,"n_rows":73,"n_cols":25,"rows_kept":73}
["gederfd levensonderhoud (het oude model)"]
[]
["Jaar",null,2014,{"$f":"+C3+1","v":2015},{"$f":"+D3+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
[]
["leeftijd partner",null,30,{"$f":"+C5+1","v":31},32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51]
["leeftijd kind 1",null,0,{"$f":"+C6+1","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
["leeftijd kind 2",null,2,{"$f":"+C7+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[]
["inkomen overledene",null,{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"}]
["inkomen partner",null,{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"}]
["inkomen kind 1",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["inkomen kind 2",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["netto gezinsinkomen",null,{"$f":"SUM(C9:C12)","v":{"v":35000,"d":"35,000"}},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"$f":"SUM(I9:I12)","v":{"v":35000,"d":"35,000"}},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"$f":"SUM(O9:O12)","v":{"v":35000,"d":"35,000"}},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"$f":"SUM(U9:U12)","v":{"v":35000,"d":"35,000"}},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"}]
[]
["vaste gezinslasten voor ongeval",{"v":0.45,"d":"45%"},{"$f":"+$B15*C13","v":{"v":15750,"d":"15,750"}},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"$f":"+$B15*I13","v":{"v":15750,"d":"15,750"}},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"$f":"+$B15*O13","v":{"v":15750,"d":"15,750"}},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"$f":"+$B15*U13","v":{"v":15750,"d":"15,750"}},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"}]
["variabele gezinslasten",{"$f":"1-B15","v":{"v":0.55,"d":"55%"}},{"$f":"+C13-C15","v":{"v":19250,"d":"19,250"}},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"},{"$f":"+I13-I15","v":{"v":19250,"d":"19,250"}},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"},{"$f":"+O13-O15","v":{"v":19250,"d":"19,250"}},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"},{"$f":"+U13-U15","v":{"v":19250,"d":"19,250"}},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"},{"v":19250,"d":"19,250"}]
[]
["weggevallen uitgaven overledene (variabel deel)",null,{"$f":"+C23/C22*C16","v":{"v":8020.833333333334,"d":"8,021"}},{"v":7700,"d":"7,700"},{"v":7403.846153846154,"d":"7,404"},{"v":7129.62962962963,"d":"7,130"},{"v":6875,"d":"6,875"},{"v":6637.931034482759,"d":"6,638"},{"$f":"+I23/I22*I16","v":{"v":6416.666666666666,"d":"6,417"}},{"v":6209.677419354838,"d":"6,210"},{"v":6111.11111111111,"d":"6,111"},{"v":5923.076923076924,"d":"5,923"},{"v":5923.076923076924,"d":"5,923"},{"v":5746.268656716417,"d":"5,746"},{"$f":"+O23/O22*O16","v":{"v":5746.268656716417,"d":"5,746"}},{"v":5579.710144927536,"d":"5,580"},{"v":5579.710144927536,"d":"5,580"},{"v":5422.5352112676055,"d":"5,423"},{"v":5422.5352112676055,"d":"5,423"},{"v":5347.222222222223,"d":"5,347"},{"$f":"+U23/U22*U16","v":{"v":5347.222222222223,"d":"5,347"}},{"v":5347.222222222223,"d":"5,347"},{"v":5347.222222222223,"d":"5,347"},{"v":5347.222222222223,"d":"5,347"}]
[]
["vaste gezinslasten na ongeval",{"v":0.4,"d":"40%"},{"$f":"+$B20*C13","v":{"v":14000,"d":"14,000"}},{"$f":"+$B20*D13","v":{"v":14000,"d":"14,000"}},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"$f":"+$B20*O13","v":{"v":14000,"d":"14,000"}},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"$f":"+$B20*U13","v":{"v":14000,"d":"14,000"}},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"},{"v":14000,"d":"14,000"}]
[]
["Amsterdamse schaal (totaal voor ongeval)",null,{"$f":"SUM(C23:C26)","v":240},250,260,270,280,290,{"$f":"SUM(I23:I26)","v":300},310,315,325,325,335,{"$f":"SUM(O23:O26)","v":335},345,345,355,355,360,{"$f":"SUM(U23:U26)","v":360},360,360,360]
["overledene",null,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
["partner",null,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
["kind 1 ",null,15,20,25,30,35,40,45,50,55,60,60,65,65,70,70,75,75,80,80,80,80,80]
["kind 2",null,25,30,35,40,45,50,55,60,60,65,65,70,70,75,75,80,80,80,80,80,80,80]
["Amsterdamse schaal (totaal na ongeval)",null,{"$f":"SUM(C24:C26)","v":140},{"$f":"SUM(D24:D26)","v":150},160,170,180,190,200,210,215,225,225,235,{"$f":"SUM(O24:O26)","v":235},245,245,255,255,260,{"$f":"SUM(U24:U26)","v":260},260,260,260]
[]
["verdeling vaste lasten na ongeval (totaal)",null,{"$f":"SUM(C30:C32)","v":4},{"$f":"SUM(D30:D32)","v":4},4,4,4,4,4,4,4,4,4,4,{"$f":"SUM(O30:O32)","v":4},4,4,4,4,4,{"$f":"SUM(U30:U32)","v":4},4,4,4]
["partner 1",null,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
["kind 1",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["kind 2",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
["behoefte partner  (variabel)","+/+",{"$f":"+C24/C22*C16","v":{"v":8020.833333333334,"d":"8,021"}},{"v":7700,"d":"7,700"},{"v":7403.846153846154,"d":"7,404"},{"v":7129.62962962963,"d":"7,130"},{"v":6875,"d":"6,875"},{"v":6637.931034482759,"d":"6,638"},{"v":6416.666666666666,"d":"6,417"},{"v":6209.677419354838,"d":"6,210"},{"v":6111.11111111111,"d":"6,111"},{"v":5923.076923076924,"d":"5,923"},{"v":5923.076923076924,"d":"5,923"},{"v":5746.268656716417,"d":"5,746"},{"$f":"+O24/O22*O16","v":{"v":5746.268656716417,"d":"5,746"}},{"v":5579.710144927536,"d":"5,580"},{"v":5579.710144927536,"d":"5,580"},{"v":5422.5352112676055,"d":"5,423"},{"v":5422.5352112676055,"d":"5,423"},{"v":5347.222222222223,"d":"5,347"},{"$f":"+U24/U22*U16","v":{"v":5347.222222222223,"d":"5,347"}},{"v":5347.222222222223,"d":"5,347"},{"v":5347.222222222223,"d":"5,347"},{"v":5347.222222222223,"d":"5,347"}]
["behoefte partner (vast)","+/+",{"$f":"+C30/C29*C20","v":{"v":7000,"d":"7,000"}},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"$f":"+O30/O29*O20","v":{"v":7000,"d":"7,000"}},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"$f":"+U30/U29*U20","v":{"v":7000,"d":"7,000"}},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"}]
["totale behoefte partner","=",{"$f":"+C35+C34","v":{"v":15020.833333333334,"d":"15,021"}},{"$f":"+D35+D34","v":{"v":14700,"d":"14,700"}},{"v":14403.846153846154,"d":"14,404"},{"v":14129.62962962963,"d":"14,130"},{"v":13875,"d":"13,875"},{"v":13637.931034482759,"d":"13,638"},{"v":13416.666666666666,"d":"13,417"},{"v":13209.677419354837,"d":"13,210"},{"v":13111.11111111111,"d":"13,111"},{"v":12923.076923076924,"d":"12,923"},{"v":12923.076923076924,"d":"12,923"},{"v":12746.268656716416,"d":"12,746"},{"v":12746.268656716416,"d":"12,746"},{"v":12579.710144927536,"d":"12,580"},{"v":12579.710144927536,"d":"12,580"},{"v":12422.535211267605,"d":"12,423"},{"v":12422.535211267605,"d":"12,423"},{"v":12347.222222222223,"d":"12,347"},{"v":12347.222222222223,"d":"12,347"},{"v":12347.222222222223,"d":"12,347"},{"v":12347.222222222223,"d":"12,347"},{"v":12347.222222222223,"d":"12,347"}]
["toegerekend inkomen na ongeval","-/-",{"$f":"+C24/C27*C10","v":{"v":7142.857142857143,"d":"7,143"}},{"v":6666.666666666666,"d":"6,667"},{"v":6250,"d":"6,250"},{"v":5882.352941176471,"d":"5,882"},{"v":5555.555555555556,"d":"5,556"},{"v":5263.157894736842,"d":"5,263"},{"v":5000,"d":"5,000"},{"v":4761.9047619047615,"d":"4,762"},{"v":4651.162790697675,"d":"4,651"},{"v":4444.444444444444,"d":"4,444"},{"v":4444.444444444444,"d":"4,444"},{"v":4255.319148936171,"d":"4,255"},{"$f":"+O24/O27*O10","v":{"v":4255.319148936171,"d":"4,255"}},{"v":4081.6326530612246,"d":"4,082"},{"v":4081.6326530612246,"d":"4,082"},{"v":3921.5686274509803,"d":"3,922"},{"v":3921.5686274509803,"d":"3,922"},{"v":3846.153846153846,"d":"3,846"},{"$f":"+U24/U27*U10","v":{"v":3846.153846153846,"d":"3,846"}},{"v":3846.153846153846,"d":"3,846"},{"v":3846.153846153846,"d":"3,846"},{"v":3846.153846153846,"d":"3,846"}]
["opkomende voordelen na ongeval (ANW, pensioen)","-/-",{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["extra kosten","+/+",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["jaarlijkse schade of overschot","=",{"$f":"+C36-C37-C38+C39","v":{"v":2877.976190476191,"d":"2,878"}},{"$f":"+D36-D37-D38+D39","v":{"v":3033.333333333334,"d":"3,033"}},{"$f":"+E36-E37-E38+E39","v":{"v":3153.8461538461543,"d":"3,154"}},{"$f":"+F36-F37-F38+F39","v":{"v":3247.2766884531593,"d":"3,247"}},{"$f":"+G36-G37-G38+G39","v":{"v":3319.4444444444453,"d":"3,319"}},{"$f":"+H36-H37-H38+H39","v":{"v":3374.7731397459174,"d":"3,375"}},{"$f":"+I36-I37-I38+I39","v":{"v":3416.666666666666,"d":"3,417"}},{"$f":"+J36-J37-J38+J39","v":{"v":3447.7726574500757,"d":"3,448"}},{"$f":"+K36-K37-K38+K39","v":{"v":8459.948320413434,"d":"8,460"}},{"$f":"+L36-L37-L38+L39","v":{"v":8478.63247863248,"d":"8,479"}},{"$f":"+M36-M37-M38+M39","v":{"v":8478.63247863248,"d":"8,479"}},{"$f":"+N36-N37-N38+N39","v":{"v":8490.949507780246,"d":"8,491"}},{"$f":"+O36-O37-O38+O39","v":{"v":8490.949507780246,"d":"8,491"}},{"$f":"+P36-P37-P38+P39","v":{"v":8498.077491866312,"d":"8,498"}},{"$f":"+Q36-Q37-Q38+Q39","v":{"v":8498.077491866312,"d":"8,498"}},{"$f":"+R36-R37-R38+R39","v":{"v":8500.966583816624,"d":"8,501"}},{"$f":"+S36-S37-S38+S39","v":{"v":8500.966583816624,"d":"8,501"}},{"$f":"+T36-T37-T38+T39","v":{"v":8501.068376068377,"d":"8,501"}},{"$f":"+U36-U37-U38+U39","v":{"v":8501.068376068377,"d":"8,501"}},{"$f":"+V36-V37-V38+V39","v":{"v":8501.068376068377,"d":"8,501"}},{"$f":"+W36-W37-W38+W39","v":{"v":8501.068376068377,"d":"8,501"}},{"$f":"+X36-X37-X38+X39","v":{"v":8501.068376068377,"d":"8,501"}}]
["Cumulatief overschot",null,{"$f":"IF(C40<0,ABS(C40),0)","v":0},{"$f":"IF((-ABS(C41)+D40)>0,0,(ABS(-ABS(C41)+D40)))","v":0},{"$f":"IF((-ABS(D41)+E40)>0,0,(ABS(-ABS(D41)+E40)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["schade wegens gederfd levensonderhoud",null,{"$f":"+IF((0-C40)<0,C40,0)","v":{"v":2877.976190476191,"d":"2,878"}},{"$f":"+IF((C41-D40)<0,(D40-C41),0)","v":{"v":3033.333333333334,"d":"3,033"}},{"$f":"+IF((D41-E40)<0,(E40-D41),0)","v":{"v":3153.8461538461543,"d":"3,154"}},{"v":3247.2766884531593,"d":"3,247"},{"v":3319.4444444444453,"d":"3,319"},{"v":3374.7731397459174,"d":"3,375"},{"v":3416.666666666666,"d":"3,417"},{"v":3447.7726574500757,"d":"3,448"},{"v":8459.948320413434,"d":"8,460"},{"v":8478.63247863248,"d":"8,479"},{"v":8478.63247863248,"d":"8,479"},{"v":8490.949507780246,"d":"8,491"},{"v":8490.949507780246,"d":"8,491"},{"v":8498.077491866312,"d":"8,498"},{"v":8498.077491866312,"d":"8,498"},{"v":8500.966583816624,"d":"8,501"},{"v":8500.966583816624,"d":"8,501"},{"v":8501.068376068377,"d":"8,501"},{"v":8501.068376068377,"d":"8,501"},{"v":8501.068376068377,"d":"8,501"},{"v":8501.068376068377,"d":"8,501"},{"v":8501.068376068377,"d":"8,501"}]
["contante waarde schade partner",null,{"$f":"+C42*C$73","v":{"v":2877.976190476191,"d":"2,878"}},{"$f":"+D42*D$73","v":{"v":2944.983818770227,"d":"2,945"}},{"$f":"+E42*E$73","v":{"v":2972.8024826526103,"d":"2,973"}},{"$f":"+F42*F$73","v":{"v":2971.7181770498573,"d":"2,972"}},{"$f":"+G42*G$73","v":{"v":2949.2833951645794,"d":"2,949"}},{"$f":"+H42*H$73","v":{"v":2911.1089556485545,"d":"2,911"}},{"$f":"+I42*I$73","v":{"v":2861.404543669152,"d":"2,861"}},{"$f":"+J42*J$73","v":{"v":2803.3546808143733,"d":"2,803"}},{"$f":"+K42*K$73","v":{"v":6678.361325953036,"d":"6,678"}},{"$f":"+L42*L$73","v":{"v":6498.165799016052,"d":"6,498"}},{"$f":"+M42*M$73","v":{"v":6308.898833996167,"d":"6,309"}},{"$f":"+N42*N$73","v":{"v":6134.042582946237,"d":"6,134"}},{"$f":"+O42*O$73","v":{"v":5955.381148491494,"d":"5,955"}},{"$f":"+P42*P$73","v":{"v":5786.77725545223,"d":"5,787"}},{"$f":"+Q42*Q$73","v":{"v":5618.230345099251,"d":"5,618"}},{"$f":"+R42*R$73","v":{"v":5456.44696624296,"d":"5,456"}},{"$f":"+S42*S$73","v":{"v":5297.521326449477,"d":"5,298"}},{"$f":"+T42*T$73","v":{"v":5143.28617477227,"d":"5,143"}},{"$f":"+U42*U$73","v":{"v":4993.4817230798735,"d":"4,993"}},{"$f":"+V42*V$73","v":{"v":4848.040507844538,"d":"4,848"}},{"$f":"+W42*W$73","v":{"v":4706.83544450926,"d":"4,707"}},{"$f":"+X42*X$73","v":{"v":4569.743150008991,"d":"4,570"}},{"$f":"SUM(C43:X43)","v":{"v":101287.84482810737,"d":"101,288"}}]
[]
[]
["behoefte kind 1 (variabel)","+/+",{"$f":"+C25/C22*C16","v":{"v":1203.125,"d":"1,203"}},{"$f":"+D25/D22*D16","v":{"v":1540,"d":"1,540"}},{"$f":"+E25/E22*E16","v":{"v":1850.9615384615386,"d":"1,851"}},{"$f":"+F25/F22*F16","v":{"v":2138.8888888888887,"d":"2,139"}},{"$f":"+G25/G22*G16","v":{"v":2406.25,"d":"2,406"}},{"$f":"+H25/H22*H16","v":{"v":2655.1724137931033,"d":"2,655"}},{"$f":"+I25/I22*I16","v":{"v":2887.5,"d":"2,888"}},{"$f":"+J25/J22*J16","v":{"v":3104.838709677419,"d":"3,105"}},{"$f":"+K25/K22*K16","v":{"v":3361.111111111111,"d":"3,361"}},{"$f":"+L25/L22*L16","v":{"v":3553.8461538461543,"d":"3,554"}},{"$f":"+M25/M22*M16","v":{"v":3553.8461538461543,"d":"3,554"}},{"$f":"+N25/N22*N16","v":{"v":3735.0746268656717,"d":"3,735"}},{"$f":"+O25/O22*O16","v":{"v":3735.0746268656717,"d":"3,735"}},{"$f":"+P25/P22*P16","v":{"v":3905.7971014492755,"d":"3,906"}},{"$f":"+Q25/Q22*Q16","v":{"v":3905.7971014492755,"d":"3,906"}},{"$f":"+R25/R22*R16","v":{"v":4066.9014084507044,"d":"4,067"}},{"$f":"+S25/S22*S16","v":{"v":4066.9014084507044,"d":"4,067"}},{"$f":"+T25/T22*T16","v":{"v":4277.777777777777,"d":"4,278"}},{"$f":"+U25/U22*U16","v":{"v":4277.777777777777,"d":"4,278"}},{"$f":"+V25/V22*V16","v":{"v":4277.777777777777,"d":"4,278"}},{"$f":"+W25/W22*W16","v":{"v":4277.777777777777,"d":"4,278"}},{"$f":"+X25/X22*X16","v":{"v":4277.777777777777,"d":"4,278"}}]
["behoefte kind (vast)","+/+",{"$f":"+C31/C29*C20","v":{"v":3500,"d":"3,500"}},{"$f":"+D31/D29*D20","v":{"v":3500,"d":"3,500"}},{"$f":"+E31/E29*E20","v":{"v":3500,"d":"3,500"}},{"$f":"+F31/F29*F20","v":{"v":3500,"d":"3,500"}},{"$f":"+G31/G29*G20","v":{"v":3500,"d":"3,500"}},{"$f":"+H31/H29*H20","v":{"v":3500,"d":"3,500"}},{"$f":"+I31/I29*I20","v":{"v":3500,"d":"3,500"}},{"$f":"+J31/J29*J20","v":{"v":3500,"d":"3,500"}},{"$f":"+K31/K29*K20","v":{"v":3500,"d":"3,500"}},{"$f":"+L31/L29*L20","v":{"v":3500,"d":"3,500"}},{"$f":"+M31/M29*M20","v":{"v":3500,"d":"3,500"}},{"$f":"+N31/N29*N20","v":{"v":3500,"d":"3,500"}},{"$f":"+O31/O29*O20","v":{"v":3500,"d":"3,500"}},{"$f":"+P31/P29*P20","v":{"v":3500,"d":"3,500"}},{"$f":"+Q31/Q29*Q20","v":{"v":3500,"d":"3,500"}},{"$f":"+R31/R29*R20","v":{"v":3500,"d":"3,500"}},{"$f":"+S31/S29*S20","v":{"v":3500,"d":"3,500"}},{"$f":"+T31/T29*T20","v":{"v":3500,"d":"3,500"}},{"$f":"+U31/U29*U20","v":{"v":3500,"d":"3,500"}},{"$f":"+V31/V29*V20","v":{"v":3500,"d":"3,500"}},{"$f":"+W31/W29*W20","v":{"v":3500,"d":"3,500"}},{"$f":"+X31/X29*X20","v":{"v":3500,"d":"3,500"}}]
["totale behoefte kind 1","=",{"$f":"+C47+C46","v":{"v":4703.125,"d":"4,703"}},{"$f":"+D47+D46","v":{"v":5040,"d":"5,040"}},{"v":5350.961538461539,"d":"5,351"},{"v":5638.888888888889,"d":"5,639"},{"v":5906.25,"d":"5,906"},{"v":6155.172413793103,"d":"6,155"},{"v":6387.5,"d":"6,388"},{"v":6604.838709677419,"d":"6,605"},{"v":6861.111111111111,"d":"6,861"},{"v":7053.846153846154,"d":"7,054"},{"v":7053.846153846154,"d":"7,054"},{"v":7235.074626865671,"d":"7,235"},{"v":7235.074626865671,"d":"7,235"},{"v":7405.797101449276,"d":"7,406"},{"v":7405.797101449276,"d":"7,406"},{"v":7566.901408450704,"d":"7,567"},{"v":7566.901408450704,"d":"7,567"},{"v":7777.777777777777,"d":"7,778"},{"v":7777.777777777777,"d":"7,778"},{"v":7777.777777777777,"d":"7,778"},{"v":7777.777777777777,"d":"7,778"},{"v":7777.777777777777,"d":"7,778"}]
["toegerekend inkomen na ongeval","-/-",{"$f":"+C25/C27*(C10+C11)","v":{"v":1071.4285714285713,"d":"1,071"}},{"$f":"+D25/D27*(D10+D11)","v":{"v":1333.3333333333333,"d":"1,333"}},{"$f":"+E25/E27*(E10+E11)","v":{"v":1562.5,"d":"1,563"}},{"$f":"+F25/F27*(F10+F11)","v":{"v":1764.7058823529412,"d":"1,765"}},{"$f":"+G25/G27*(G10+G11)","v":{"v":1944.4444444444446,"d":"1,944"}},{"$f":"+H25/H27*(H10+H11)","v":{"v":2105.2631578947367,"d":"2,105"}},{"$f":"+I25/I27*(I10+I11)","v":{"v":2250,"d":"2,250"}},{"$f":"+J25/J27*(J10+J11)","v":{"v":2380.9523809523807,"d":"2,381"}},{"$f":"+K25/K27*(K10+K11)","v":{"v":2558.139534883721,"d":"2,558"}},{"$f":"+L25/L27*(L10+L11)","v":{"v":2666.6666666666665,"d":"2,667"}},{"$f":"+M25/M27*(M10+M11)","v":{"v":2666.6666666666665,"d":"2,667"}},{"$f":"+N25/N27*(N10+N11)","v":{"v":2765.9574468085107,"d":"2,766"}},{"$f":"+O25/O27*(O10+O11)","v":{"v":2765.9574468085107,"d":"2,766"}},{"$f":"+P25/P27*(P10+P11)","v":{"v":2857.142857142857,"d":"2,857"}},{"$f":"+Q25/Q27*(Q10+Q11)","v":{"v":2857.142857142857,"d":"2,857"}},{"$f":"+R25/R27*(R10+R11)","v":{"v":2941.1764705882356,"d":"2,941"}},{"$f":"+S25/S27*(S10+S11)","v":{"v":2941.1764705882356,"d":"2,941"}},{"$f":"+T25/T27*(T10+T11)","v":{"v":3076.923076923077,"d":"3,077"}},{"$f":"+U25/U27*(U10+U11)","v":{"v":3076.923076923077,"d":"3,077"}},{"$f":"+V25/V27*(V10+V11)","v":{"v":3076.923076923077,"d":"3,077"}},{"$f":"+W25/W27*(W10+W11)","v":{"v":3076.923076923077,"d":"3,077"}},{"$f":"+X25/X27*(X10+X11)","v":{"v":3076.923076923077,"d":"3,077"}}]
["opkomende voordelen na ongeval (ANW, pensioen)","-/-",{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},0,0,0,0,0,0,0,0,0,0,0]
["extra kosten","+/+",0,0,0,0,0,0,0,0,0,0,0,0]
["jaarlijkse schade of overschot kind 1","=",{"$f":"+C48-C49-C50+C51","v":{"v":2631.6964285714284,"d":"2,632"}},{"$f":"+D48-D49-D50+D51","v":{"v":2706.666666666667,"d":"2,707"}},{"$f":"+E48-E49-E50+E51","v":{"v":2788.461538461539,"d":"2,788"}},{"$f":"+F48-F49-F50+F51","v":{"v":2874.1830065359472,"d":"2,874"}},{"$f":"+G48-G49-G50+G51","v":{"v":2961.8055555555557,"d":"2,962"}},{"$f":"+H48-H49-H50+H51","v":{"v":3049.9092558983666,"d":"3,050"}},{"$f":"+I48-I49-I50+I51","v":{"v":3137.5,"d":"3,138"}},{"$f":"+J48-J49-J50+J51","v":{"v":3223.886328725038,"d":"3,224"}},{"$f":"+K48-K49-K50+K51","v":{"v":3302.97157622739,"d":"3,303"}},{"$f":"+L48-L49-L50+L51","v":{"v":3387.179487179488,"d":"3,387"}},{"$f":"+M48-M49-M50+M51","v":{"v":3387.179487179488,"d":"3,387"}},{"$f":"+N48-N49-N50+N51","v":{"v":4469.117180057161,"d":"4,469"}},{"$f":"+O48-O49-O50+O51","v":{"v":4469.117180057161,"d":"4,469"}},{"$f":"+P48-P49-P50+P51","v":{"v":4548.654244306419,"d":"4,549"}},{"$f":"+Q48-Q49-Q50+Q51","v":{"v":4548.654244306419,"d":"4,549"}},{"$f":"+R48-R49-R50+R51","v":{"v":4625.724937862469,"d":"4,626"}},{"$f":"+S48-S49-S50+S51","v":{"v":4625.724937862469,"d":"4,626"}},{"$f":"+T48-T49-T50+T51","v":{"v":4700.8547008547,"d":"4,701"}},{"$f":"+U48-U49-U50+U51","v":{"v":4700.8547008547,"d":"4,701"}},{"$f":"+V48-V49-V50+V51","v":{"v":4700.8547008547,"d":"4,701"}},{"$f":"+W48-W49-W50+W51","v":{"v":4700.8547008547,"d":"4,701"}},{"$f":"+X48-X49-X50+X51","v":{"v":4700.8547008547,"d":"4,701"}}]
["Cumulatief overschot",null,{"$f":"IF(C52<0,ABS(C52),0)","v":0},{"$f":"IF((-ABS(C53)+D52)>0,0,(ABS(-ABS(C53)+D52)))","v":0},{"$f":"IF((-ABS(D53)+E52)>0,0,(ABS(-ABS(D53)+E52)))","v":0},{"$f":"IF((-ABS(E53)+F52)>0,0,(ABS(-ABS(E53)+F52)))","v":0},{"$f":"IF((-ABS(F53)+G52)>0,0,(ABS(-ABS(F53)+G52)))","v":0},{"$f":"IF((-ABS(G53)+H52)>0,0,(ABS(-ABS(G53)+H52)))","v":0},{"$f":"IF((-ABS(H53)+I52)>0,0,(ABS(-ABS(H53)+I52)))","v":0},{"$f":"IF((-ABS(I53)+J52)>0,0,(ABS(-ABS(I53)+J52)))","v":0},{"$f":"IF((-ABS(J53)+K52)>0,0,(ABS(-ABS(J53)+K52)))","v":0},{"$f":"IF((-ABS(K53)+L52)>0,0,(ABS(-ABS(K53)+L52)))","v":0},{"$f":"IF((-ABS(L53)+M52)>0,0,(ABS(-ABS(L53)+M52)))","v":0},{"$f":"IF((-ABS(M53)+N52)>0,0,(ABS(-ABS(M53)+N52)))","v":0},{"$f":"IF((-ABS(N53)+O52)>0,0,(ABS(-ABS(N53)+O52)))","v":0},{"$f":"IF((-ABS(O53)+P52)>0,0,(ABS(-ABS(O53)+P52)))","v":0},{"$f":"IF((-ABS(P53)+Q52)>0,0,(ABS(-ABS(P53)+Q52)))","v":0},{"$f":"IF((-ABS(Q53)+R52)>0,0,(ABS(-ABS(Q53)+R52)))","v":0},{"$f":"IF((-ABS(R53)+S52)>0,0,(ABS(-ABS(R53)+S52)))","v":0},{"$f":"IF((-ABS(S53)+T52)>0,0,(ABS(-ABS(S53)+T52)))","v":0},{"$f":"IF((-ABS(T53)+U52)>0,0,(ABS(-ABS(T53)+U52)))","v":0},{"$f":"IF((-ABS(U53)+V52)>0,0,(ABS(-ABS(U53)+V52)))","v":0},{"$f":"IF((-ABS(V53)+W52)>0,0,(ABS(-ABS(V53)+W52)))","v":0},{"$f":"IF((-ABS(W53)+X52)>0,0,(ABS(-ABS(W53)+X52)))","v":0}]
["schade wegens gederfd levensonderhoud",null,{"$f":"+IF((0-C52)<0,C52,0)","v":{"v":2631.6964285714284,"d":"2,632"}},{"$f":"+IF((C53-D52)<0,(D52-C53),0)","v":{"v":2706.666666666667,"d":"2,707"}},{"$f":"+IF((D53-E52)<0,(E52-D53),0)","v":{"v":2788.461538461539,"d":"2,788"}},{"v":2874.1830065359472,"d":"2,874"},{"v":2961.8055555555557,"d":"2,962"},{"v":3049.9092558983666,"d":"3,050"},{"v":3137.5,"d":"3,138"},{"v":3223.886328725038,"d":"3,224"},{"v":3302.97157622739,"d":"3,303"},{"v":3387.179487179488,"d":"3,387"},{"v":3387.179487179488,"d":"3,387"},{"v":4469.117180057161,"d":"4,469"},{"v":4469.117180057161,"d":"4,469"},{"v":4548.654244306419,"d":"4,549"},{"v":4548.654244306419,"d":"4,549"},{"v":4625.724937862469,"d":"4,626"},{"v":4625.724937862469,"d":"4,626"},{"v":4700.8547008547,"d":"4,701"},{"v":4700.8547008547,"d":"4,701"},{"v":4700.8547008547,"d":"4,701"},{"v":4700.8547008547,"d":"4,701"},{"v":4700.8547008547,"d":"4,701"}]
["contante waarde schade kind 1 ",null,{"$f":"+C54*C$73","v":{"v":2631.6964285714284,"d":"2,632"}},{"$f":"+D54*D$73","v":{"v":2627.8317152103564,"d":"2,628"}},{"$f":"+E54*E$73","v":{"v":2628.3924389306617,"d":"2,628"}},{"$f":"+F54*F$73","v":{"v":2630.28460588596,"d":"2,630"}},{"$f":"+G54*G$73","v":{"v":2631.525874555843,"d":"2,632"}},{"$f":"+H54*H$73","v":{"v":2630.8785157125003,"d":"2,631"}},{"$f":"+I54*I$73","v":{"v":2627.606855344966,"d":"2,628"}},{"$f":"+J54*J$73","v":{"v":2621.3146074222173,"d":"2,621"}},{"$f":"+K54*K$73","v":{"v":2607.396262950357,"d":"2,607"}},{"$f":"+L54*L$73","v":{"v":2595.9910344254654,"d":"2,596"}},{"$f":"+M54*M$73","v":{"v":2520.379645073267,"d":"2,520"}},{"$f":"+N54*N$73","v":{"v":3228.585338486355,"d":"3,229"}},{"$f":"+O54*O$73","v":{"v":3134.54887231685,"d":"3,135"}},{"$f":"+P54*P$73","v":{"v":3097.412202826112,"d":"3,097"}},{"$f":"+Q54*Q$73","v":{"v":3007.1963134234093,"d":"3,007"}},{"$f":"+R54*R$73","v":{"v":2969.076816737965,"d":"2,969"}},{"$f":"+S54*S$73","v":{"v":2882.5988512019085,"d":"2,883"}},{"$f":"+T54*T$73","v":{"v":2844.094403543796,"d":"2,844"}},{"$f":"+U54*U$73","v":{"v":2761.2567024697046,"d":"2,761"}},{"$f":"+V54*V$73","v":{"v":2680.831749970587,"d":"2,681"}},{"$f":"+W54*W$73","v":{"v":2602.7492718161043,"d":"2,603"}},{"$f":"+X54*X$73","v":{"v":2526.9410405981594,"d":"2,527"}},{"$f":"SUM(C55:X55)","v":{"v":60488.589547473974,"d":"60,489"}}]
[]
[]
["behoefte kind 2 (variabel)","+/+",{"$f":"+C26/C22*C16","v":{"v":2005.2083333333335,"d":"2,005"}},{"$f":"+D26/D22*D16","v":{"v":2310,"d":"2,310"}},{"$f":"+E26/E22*E16","v":{"v":2591.346153846154,"d":"2,591"}},{"$f":"+F26/F22*F16","v":{"v":2851.8518518518517,"d":"2,852"}},{"$f":"+G26/G22*G16","v":{"v":3093.7500000000005,"d":"3,094"}},{"$f":"+H26/H22*H16","v":{"v":3318.9655172413795,"d":"3,319"}},{"$f":"+I26/I22*I16","v":{"v":3529.1666666666665,"d":"3,529"}},{"$f":"+J26/J22*J16","v":{"v":3725.806451612903,"d":"3,726"}},{"$f":"+K26/K22*K16","v":{"v":3666.6666666666665,"d":"3,667"}},{"$f":"+L26/L22*L16","v":{"v":3850,"d":"3,850"}},{"$f":"+M26/M22*M16","v":{"v":3850,"d":"3,850"}},{"$f":"+N26/N22*N16","v":{"v":4022.3880597014922,"d":"4,022"}},{"$f":"+O26/O22*O16","v":{"v":4022.3880597014922,"d":"4,022"}},{"$f":"+P26/P22*P16","v":{"v":4184.782608695652,"d":"4,185"}},{"$f":"+Q26/Q22*Q16","v":{"v":4184.782608695652,"d":"4,185"}},{"$f":"+R26/R22*R16","v":{"v":4338.028169014085,"d":"4,338"}},{"$f":"+S26/S22*S16","v":{"v":4338.028169014085,"d":"4,338"}},{"$f":"+T26/T22*T16","v":{"v":4277.777777777777,"d":"4,278"}},{"$f":"+U26/U22*U16","v":{"v":4277.777777777777,"d":"4,278"}},{"$f":"+V26/V22*V16","v":{"v":4277.777777777777,"d":"4,278"}},{"$f":"+W26/W22*W16","v":{"v":4277.777777777777,"d":"4,278"}},{"$f":"+X26/X22*X16","v":{"v":4277.777777777777,"d":"4,278"}}]
["behoefte kind (vast)","+/+",{"$f":"+C32/C29*C20","v":{"v":3500,"d":"3,500"}},{"$f":"+D32/D29*D20","v":{"v":3500,"d":"3,500"}},{"$f":"+E32/E29*E20","v":{"v":3500,"d":"3,500"}},{"$f":"+F32/F29*F20","v":{"v":3500,"d":"3,500"}},{"$f":"+G32/G29*G20","v":{"v":3500,"d":"3,500"}},{"$f":"+H32/H29*H20","v":{"v":3500,"d":"3,500"}},{"$f":"+I32/I29*I20","v":{"v":3500,"d":"3,500"}},{"$f":"+J32/J29*J20","v":{"v":3500,"d":"3,500"}},{"$f":"+K32/K29*K20","v":{"v":3500,"d":"3,500"}},{"$f":"+L32/L29*L20","v":{"v":3500,"d":"3,500"}},{"$f":"+M32/M29*M20","v":{"v":3500,"d":"3,500"}},{"$f":"+N32/N29*N20","v":{"v":3500,"d":"3,500"}},{"$f":"+O32/O29*O20","v":{"v":3500,"d":"3,500"}},{"$f":"+P32/P29*P20","v":{"v":3500,"d":"3,500"}},{"$f":"+Q32/Q29*Q20","v":{"v":3500,"d":"3,500"}},{"$f":"+R32/R29*R20","v":{"v":3500,"d":"3,500"}},{"$f":"+S32/S29*S20","v":{"v":3500,"d":"3,500"}},{"$f":"+T32/T29*T20","v":{"v":3500,"d":"3,500"}},{"$f":"+U32/U29*U20","v":{"v":3500,"d":"3,500"}},{"$f":"+V32/V29*V20","v":{"v":3500,"d":"3,500"}},{"$f":"+W32/W29*W20","v":{"v":3500,"d":"3,500"}},{"$f":"+X32/X29*X20","v":{"v":3500,"d":"3,500"}}]
["totale behoefte kind 2",null,{"$f":"+C59+C58","v":{"v":5505.208333333334,"d":"5,505"}},{"$f":"+D59+D58","v":{"v":5810,"d":"5,810"}},{"v":6091.346153846154,"d":"6,091"},{"v":6351.851851851852,"d":"6,352"},{"v":6593.75,"d":"6,594"},{"v":6818.9655172413795,"d":"6,819"},{"v":7029.166666666666,"d":"7,029"},{"v":7225.806451612903,"d":"7,226"},{"v":7166.666666666666,"d":"7,167"},{"v":7350,"d":"7,350"},{"v":7350,"d":"7,350"},{"v":7522.388059701492,"d":"7,522"},{"v":7522.388059701492,"d":"7,522"},{"v":7684.782608695652,"d":"7,685"},{"v":7684.782608695652,"d":"7,685"},{"v":7838.028169014085,"d":"7,838"},{"v":7838.028169014085,"d":"7,838"},{"v":7777.777777777777,"d":"7,778"},{"v":7777.777777777777,"d":"7,778"},{"v":7777.777777777777,"d":"7,778"},{"v":7777.777777777777,"d":"7,778"},{"v":7777.777777777777,"d":"7,778"}]
["toegerekend inkomen na ongeval","-/-",{"$f":"+(C26/C27*(C10+C12))","v":{"v":1785.7142857142858,"d":"1,786"}},{"$f":"+(D26/D27*(D10+D12))","v":{"v":2000,"d":"2,000"}},{"$f":"+(E26/E27*(E10+E12))","v":{"v":2187.5,"d":"2,188"}},{"$f":"+(F26/F27*(F10+F12))","v":{"v":2352.9411764705883,"d":"2,353"}},{"$f":"+(G26/G27*(G10+G12))","v":{"v":2500,"d":"2,500"}},{"$f":"+(H26/H27*(H10+H12))","v":{"v":2631.578947368421,"d":"2,632"}},{"$f":"+(I26/I27*(I10+I12))","v":{"v":2750,"d":"2,750"}},{"$f":"+(J26/J27*(J10+J12))","v":{"v":2857.142857142857,"d":"2,857"}},{"$f":"+(K26/K27*(K10+K12))","v":{"v":2790.6976744186045,"d":"2,791"}},{"$f":"+(L26/L27*(L10+L12))","v":{"v":2888.8888888888887,"d":"2,889"}},{"$f":"+(M26/M27*(M10+M12))","v":{"v":2888.8888888888887,"d":"2,889"}},{"$f":"+(N26/N27*(N10+N12))","v":{"v":2978.723404255319,"d":"2,979"}},{"$f":"+(O26/O27*(O10+O12))","v":{"v":2978.723404255319,"d":"2,979"}},{"$f":"+(P26/P27*(P10+P12))","v":{"v":3061.2244897959185,"d":"3,061"}},{"$f":"+(Q26/Q27*(Q10+Q12))","v":{"v":3061.2244897959185,"d":"3,061"}},{"$f":"+(R26/R27*(R10+R12))","v":{"v":3137.254901960784,"d":"3,137"}},{"$f":"+(S26/S27*(S10+S12))","v":{"v":3137.254901960784,"d":"3,137"}},{"$f":"+(T26/T27*(T10+T12))","v":{"v":3076.923076923077,"d":"3,077"}},{"$f":"+(U26/U27*(U10+U12))","v":{"v":3076.923076923077,"d":"3,077"}},{"$f":"+(V26/V27*(V10+V12))","v":{"v":3076.923076923077,"d":"3,077"}},{"$f":"+(W26/W27*(W10+W12))","v":{"v":3076.923076923077,"d":"3,077"}},{"$f":"+(X26/X27*(X10+X12))","v":{"v":3076.923076923077,"d":"3,077"}}]
["opkomende voordelen na ongeval (ANW, pensioen)","-/-",{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},0,0,0,0,0,0,0,0,0,0,0]
["extra kosten","+/+",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["jaarlijkse schade of overschot kind2","=",{"$f":"+C60-C61-C62+C63","v":{"v":2719.494047619048,"d":"2,719"}},{"$f":"+D60-D61-D62+D63","v":{"v":2810,"d":"2,810"}},{"$f":"+E60-E61-E62+E63","v":{"v":2903.8461538461543,"d":"2,904"}},{"$f":"+F60-F61-F62+F63","v":{"v":2998.910675381264,"d":"2,999"}},{"$f":"+G60-G61-G62+G63","v":{"v":3093.75,"d":"3,094"}},{"$f":"+H60-H61-H62+H63","v":{"v":3187.3865698729587,"d":"3,187"}},{"$f":"+I60-I61-I62+I63","v":{"v":3279.166666666666,"d":"3,279"}},{"$f":"+J60-J61-J62+J63","v":{"v":3368.6635944700465,"d":"3,369"}},{"$f":"+K60-K61-K62+K63","v":{"v":3375.968992248061,"d":"3,376"}},{"$f":"+L60-L61-L62+L63","v":{"v":3461.1111111111113,"d":"3,461"}},{"$f":"+M60-M61-M62+M63","v":{"v":3461.1111111111113,"d":"3,461"}},{"$f":"+N60-N61-N62+N63","v":{"v":4543.664655446173,"d":"4,544"}},{"$f":"+O60-O61-O62+O63","v":{"v":4543.664655446173,"d":"4,544"}},{"$f":"+P60-P61-P62+P63","v":{"v":4623.558118899733,"d":"4,624"}},{"$f":"+Q60-Q61-Q62+Q63","v":{"v":4623.558118899733,"d":"4,624"}},{"$f":"+R60-R61-R62+R63","v":{"v":4700.7732670533005,"d":"4,701"}},{"$f":"+S60-S61-S62+S63","v":{"v":4700.7732670533005,"d":"4,701"}},{"$f":"+T60-T61-T62+T63","v":{"v":4700.8547008547,"d":"4,701"}},{"$f":"+U60-U61-U62+U63","v":{"v":4700.8547008547,"d":"4,701"}},{"$f":"+V60-V61-V62+V63","v":{"v":4700.8547008547,"d":"4,701"}},{"$f":"+W60-W61-W62+W63","v":{"v":4700.8547008547,"d":"4,701"}},{"$f":"+X60-X61-X62+X63","v":{"v":4700.8547008547,"d":"4,701"}}]
["Cumulatief overschot",null,{"$f":"IF(C64<0,ABS(C64),0)","v":0},{"$f":"IF((-ABS(C65)+D64)>0,0,(ABS(-ABS(C65)+D64)))","v":0},{"$f":"IF((-ABS(D65)+E64)>0,0,(ABS(-ABS(D65)+E64)))","v":0},{"$f":"IF((-ABS(E65)+F64)>0,0,(ABS(-ABS(E65)+F64)))","v":0},{"$f":"IF((-ABS(F65)+G64)>0,0,(ABS(-ABS(F65)+G64)))","v":0},{"$f":"IF((-ABS(G65)+H64)>0,0,(ABS(-ABS(G65)+H64)))","v":0},{"$f":"IF((-ABS(H65)+I64)>0,0,(ABS(-ABS(H65)+I64)))","v":0},{"$f":"IF((-ABS(I65)+J64)>0,0,(ABS(-ABS(I65)+J64)))","v":0},{"$f":"IF((-ABS(J65)+K64)>0,0,(ABS(-ABS(J65)+K64)))","v":0},{"$f":"IF((-ABS(K65)+L64)>0,0,(ABS(-ABS(K65)+L64)))","v":0},{"$f":"IF((-ABS(L65)+M64)>0,0,(ABS(-ABS(L65)+M64)))","v":0},{"$f":"IF((-ABS(M65)+N64)>0,0,(ABS(-ABS(M65)+N64)))","v":0},{"$f":"IF((-ABS(N65)+O64)>0,0,(ABS(-ABS(N65)+O64)))","v":0},{"$f":"IF((-ABS(O65)+P64)>0,0,(ABS(-ABS(O65)+P64)))","v":0},{"$f":"IF((-ABS(P65)+Q64)>0,0,(ABS(-ABS(P65)+Q64)))","v":0},{"$f":"IF((-ABS(Q65)+R64)>0,0,(ABS(-ABS(Q65)+R64)))","v":0},{"$f":"IF((-ABS(R65)+S64)>0,0,(ABS(-ABS(R65)+S64)))","v":0},{"$f":"IF((-ABS(S65)+T64)>0,0,(ABS(-ABS(S65)+T64)))","v":0},{"$f":"IF((-ABS(T65)+U64)>0,0,(ABS(-ABS(T65)+U64)))","v":0},{"$f":"IF((-ABS(U65)+V64)>0,0,(ABS(-ABS(U65)+V64)))","v":0},{"$f":"IF((-ABS(V65)+W64)>0,0,(ABS(-ABS(V65)+W64)))","v":0},{"$f":"IF((-ABS(W65)+X64)>0,0,(ABS(-ABS(W65)+X64)))","v":0}]
["schade wegens gederfd levensonderhoud",null,{"$f":"+IF((0-C64)<0,C64,0)","v":{"v":2719.494047619048,"d":"2,719"}},{"$f":"+IF((C65-D64)<0,(D64-C65),0)","v":{"v":2810,"d":"2,810"}},{"$f":"+IF((D65-E64)<0,(E64-D65),0)","v":{"v":2903.8461538461543,"d":"2,904"}},{"v":2998.910675381264,"d":"2,999"},{"v":3093.75,"d":"3,094"},{"v":3187.3865698729587,"d":"3,187"},{"v":3279.166666666666,"d":"3,279"},{"v":3368.6635944700465,"d":"3,369"},{"v":3375.968992248061,"d":"3,376"},{"v":3461.1111111111113,"d":"3,461"},{"v":3461.1111111111113,"d":"3,461"},{"v":4543.664655446173,"d":"4,544"},{"v":4543.664655446173,"d":"4,544"},{"v":4623.558118899733,"d":"4,624"},{"v":4623.558118899733,"d":"4,624"},{"v":4700.7732670533005,"d":"4,701"},{"v":4700.7732670533005,"d":"4,701"},{"v":4700.8547008547,"d":"4,701"},{"v":4700.8547008547,"d":"4,701"},{"v":4700.8547008547,"d":"4,701"},{"v":4700.8547008547,"d":"4,701"},{"v":4700.8547008547,"d":"4,701"}]
["contante waarde schade kind 2",null,{"$f":"+C66*C$73","v":{"v":2719.494047619048,"d":"2,719"}},{"$f":"+D66*D$73","v":{"v":2728.1553398058254,"d":"2,728"}},{"$f":"+E66*E$73","v":{"v":2737.153505369172,"d":"2,737"}},{"$f":"+F66*F$73","v":{"v":2744.4280917203146,"d":"2,744"}},{"$f":"+G66*G$73","v":{"v":2748.7568044891627,"d":"2,749"}},{"$f":"+H66*H$73","v":{"v":2749.4676544005233,"d":"2,749"}},{"$f":"+I66*I$73","v":{"v":2746.2504583751497,"d":"2,746"}},{"$f":"+J66*J$73","v":{"v":2739.031773234985,"d":"2,739"}},{"$f":"+K66*K$73","v":{"v":2665.021097238131,"d":"2,665"}},{"$f":"+L66*L$73","v":{"v":2652.653468055998,"d":"2,653"}},{"$f":"+M66*M$73","v":{"v":2575.391716559221,"d":"2,575"}},{"$f":"+N66*N$73","v":{"v":3282.4400208241,"d":"3,282"}},{"$f":"+O66*O$73","v":{"v":3186.834971673884,"d":"3,187"}},{"$f":"+P66*P$73","v":{"v":3148.4180966011104,"d":"3,148"}},{"$f":"+Q66*Q$73","v":{"v":3056.716598641854,"d":"3,057"}},{"$f":"+R66*R$73","v":{"v":3017.247483461262,"d":"3,017"}},{"$f":"+S66*S$73","v":{"v":2929.3664887973423,"d":"2,929"}},{"$f":"+T66*T$73","v":{"v":2844.094403543796,"d":"2,844"}},{"$f":"+U66*U$73","v":{"v":2761.2567024697046,"d":"2,761"}},{"$f":"+V66*V$73","v":{"v":2680.831749970587,"d":"2,681"}},{"$f":"+W66*W$73","v":{"v":2602.7492718161043,"d":"2,603"}},{"$f":"+X66*X$73","v":{"v":2526.9410405981594,"d":"2,527"}},{"$f":"SUM(C67:X67)","v":{"v":61842.700785265435,"d":"61,843"}}]
[]
[]
[{"$nulls":24},{"$f":"+Y67+Y55+Y43","v":{"v":223619.13516084678,"d":"223,619"}}]
[]
["rekenrente",null,{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"}]
["contante waarde factor",null,{"$f":"1/POWER((1+C72),C$1)","v":{"v":1,"d":"1.000000"}},{"$f":"1/POWER((1+D72),(D3-$C$3))","v":{"v":0.970873786407767,"d":"0.970874"}},{"$f":"1/POWER((1+E72),(E3-$C$3))","v":{"v":0.9425959091337544,"d":"0.942596"}},{"$f":"1/POWER((1+F72),(F3-$C$3))","v":{"v":0.9151416593531596,"d":"0.915142"}},{"$f":"1/POWER((1+G72),(G3-$C$3))","v":{"v":0.888487047915689,"d":"0.888487"}},{"$f":"1/POWER((1+H72),(H3-$C$3))","v":{"v":0.8626087843841641,"d":"0.862609"}},{"$f":"1/POWER((1+I72),(I3-$C$3))","v":{"v":0.8374842566836544,"d":"0.837484"}},{"$f":"1/POWER((1+J72),(J3-$C$3))","v":{"v":0.8130915113433538,"d":"0.813092"}},{"$f":"1/POWER((1+K72),(K3-$C$3))","v":{"v":0.7894092343139357,"d":"0.789409"}},{"$f":"1/POWER((1+L72),(L3-$C$3))","v":{"v":0.766416732343627,"d":"0.766417"}},{"$f":"1/POWER((1+M72),(M3-$C$3))","v":{"v":0.7440939148967252,"d":"0.744094"}},{"$f":"1/POWER((1+N72),(N3-$C$3))","v":{"v":0.7224212765987623,"d":"0.722421"}},{"$f":"1/POWER((1+O72),(O3-$C$3))","v":{"v":0.7013798801929733,"d":"0.701380"}},{"$f":"1/POWER((1+P72),(P3-$C$3))","v":{"v":0.6809513399931779,"d":"0.680951"}},{"$f":"1/POWER((1+Q72),(Q3-$C$3))","v":{"v":0.6611178058186192,"d":"0.661118"}},{"$f":"1/POWER((1+R72),(R3-$C$3))","v":{"v":0.6418619473967176,"d":"0.641862"}},{"$f":"1/POWER((1+S72),(S3-$C$3))","v":{"v":0.6231669392201143,"d":"0.623167"}},{"$f":"1/POWER((1+T72),(T3-$C$3))","v":{"v":0.6050164458447712,"d":"0.605016"}},{"$f":"1/POWER((1+U72),(U3-$C$3))","v":{"v":0.5873946076162827,"d":"0.587395"}},{"$f":"1/POWER((1+V72),(V3-$C$3))","v":{"v":0.570286026811925,"d":"0.570286"}},{"$f":"1/POWER((1+W72),(W3-$C$3))","v":{"v":0.553675754186335,"d":"0.553676"}},{"$f":"1/POWER((1+X72),(X3-$C$3))","v":{"v":0.5375492759090631,"d":"0.537549"}}]

{"sheet":"amsterdamse schaal","index":1,"n_rows":31,"n_cols":20,"rows_kept":31}
["leeftijd",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,15,20,25,30,35,40,45,50,55,60,60,65,65,70,70,75,75,80,80]
{"$rows_empty":7}
["Amsterdamse schaal"]
[]
["man ",100]
["vrouw",100]
["kind 0 jaar",15]
["kind 1 jaar",20]
["kind 2 jaar",25]
["kind 3 jaar",30]
["kind 4 jaar",35]
["kind 5 jaar",40]
["kind 6 jaar",45]
["kind 7 jaar",50]
["kind 8 jaar",55]
["kind 9 jaar",60]
["kind 10 jaar",60]
["kind 11 jaar",65]
["kind 12 jaar",65]
["kind 13 jaar",70]
["kind 14 jaar",70]
["kind 15 jaar",75]
["kind 16 jaar",75]
["kind >= 17 jaar",80]